First, we need to connect to NewsroomDB and download all shootings and homicides.


In [22]:
import os
import requests

def get_table_data(table_name):
    url = '%stable/json/%s' % (os.environ['NEWSROOMDB_URL'], table_name)
    try:
        r = requests.get(url)
        return r.json()
    except:
        print 'doh'
        return get_table_data(table_name)

homicides = get_table_data('homicides')
shootings = get_table_data('shootings')

print 'Found %d homicides and %d shootings' % (len(homicides), len(shootings))


doh
doh
doh
Found 1519 homicides and 11463 shootings

Right now, we're interested in all shootings and homicides for the current month. So filter the lists based on whatever that month is.


In [24]:
from datetime import date, datetime
today = date.today()

homicides_this_month = {}
for h in homicides:
    try:
        dt = datetime.strptime(h['Occ Date'], '%Y-%m-%d')
    except ValueError:
        continue
    if dt.month == today.month:
        if dt.year not in homicides_this_month:
            homicides_this_month[dt.year] = []
        homicides_this_month[dt.year].append(h)

shootings_this_month = {}
for s in shootings:
    try:
        dt = datetime.strptime(s['Date'], '%Y-%m-%d')
    except ValueError:
        continue
    if dt.month == today.month:
        if dt.year not in shootings_this_month:
            shootings_this_month[dt.year] = []
        shootings_this_month[dt.year].append(s)

for year in sorted(shootings_this_month.keys(), reverse=True):
    try:
        s = len(shootings_this_month[year])
    except:
        s = 0
    try:
        h = len(homicides_this_month[year])
    except:
        h = 0
    print '%d:\t%d shootings\t\t%d homicides' % (year, s, h)


2016:	257 shootings		47 homicides
2015:	145 shootings		32 homicides
2014:	101 shootings		24 homicides
2013:	190 shootings		44 homicides
2012:	174 shootings		0 homicides
1984:	1 shootings		0 homicides

Now let's find the days without a shooting.


In [12]:
from datetime import date, timedelta

test_date = date.today()
one_day = timedelta(days=1)

shooting_days = {}
for shooting in shootings:
    if shooting['Date'] not in shooting_days:
        shooting_days[shooting['Date']] = 0
    shooting_days[shooting['Date']] += 1

while test_date.year > 2013:
    if test_date.strftime('%Y-%m-%d') not in shooting_days:
        print 'No shootings on %s' % test_date
    test_date -= one_day


No shootings on 2015-02-28
No shootings on 2015-02-24
No shootings on 2015-02-18
No shootings on 2015-02-05
No shootings on 2015-02-02
No shootings on 2015-01-15
No shootings on 2015-01-12
No shootings on 2015-01-07
No shootings on 2014-11-14
No shootings on 2014-05-23
No shootings on 2014-03-26
No shootings on 2014-03-13
No shootings on 2014-02-26
No shootings on 2014-02-17
No shootings on 2014-02-16
No shootings on 2014-02-11
No shootings on 2014-01-23
No shootings on 2014-01-21
No shootings on 2014-01-10
No shootings on 2014-01-06
No shootings on 2014-01-02

And days without a homicide.


In [13]:
from datetime import date, timedelta

test_date = date.today()
one_day = timedelta(days=1)

homicide_days = {}
for homicide in homicides:
    if homicide['Occ Date'] not in homicide_days:
        homicide_days[homicide['Occ Date']] = 0
    homicide_days[homicide['Occ Date']] += 1

while test_date.year > 2013:
    if test_date.strftime('%Y-%m-%d') not in homicide_days:
        print 'No homicides on %s' % test_date
    test_date -= one_day


No homicides on 2016-03-25
No homicides on 2016-03-24
No homicides on 2016-03-23
No homicides on 2016-03-22
No homicides on 2016-03-21
No homicides on 2016-03-20
No homicides on 2016-03-19
No homicides on 2016-03-17
No homicides on 2016-03-16
No homicides on 2016-03-06
No homicides on 2016-03-05
No homicides on 2016-03-03
No homicides on 2016-02-29
No homicides on 2016-02-28
No homicides on 2016-02-25
No homicides on 2016-02-23
No homicides on 2016-02-15
No homicides on 2016-02-12
No homicides on 2016-02-10
No homicides on 2016-02-09
No homicides on 2016-02-06
No homicides on 2016-01-22
No homicides on 2016-01-19
No homicides on 2016-01-15
No homicides on 2016-01-12
No homicides on 2016-01-10
No homicides on 2016-01-03
No homicides on 2015-12-31
No homicides on 2015-12-30
No homicides on 2015-12-28
No homicides on 2015-12-21
No homicides on 2015-12-19
No homicides on 2015-12-18
No homicides on 2015-12-15
No homicides on 2015-12-14
No homicides on 2015-12-09
No homicides on 2015-12-07
No homicides on 2015-12-02
No homicides on 2015-11-24
No homicides on 2015-11-20
No homicides on 2015-11-19
No homicides on 2015-11-16
No homicides on 2015-11-15
No homicides on 2015-11-13
No homicides on 2015-11-10
No homicides on 2015-11-08
No homicides on 2015-11-04
No homicides on 2015-10-30
No homicides on 2015-10-29
No homicides on 2015-10-28
No homicides on 2015-10-27
No homicides on 2015-10-22
No homicides on 2015-10-20
No homicides on 2015-10-15
No homicides on 2015-10-05
No homicides on 2015-10-03
No homicides on 2015-10-02
No homicides on 2015-10-01
No homicides on 2015-09-12
No homicides on 2015-09-11
No homicides on 2015-09-09
No homicides on 2015-09-05
No homicides on 2015-08-28
No homicides on 2015-08-18
No homicides on 2015-08-10
No homicides on 2015-08-08
No homicides on 2015-08-04
No homicides on 2015-08-03
No homicides on 2015-07-29
No homicides on 2015-07-23
No homicides on 2015-07-22
No homicides on 2015-07-19
No homicides on 2015-07-16
No homicides on 2015-07-14
No homicides on 2015-06-26
No homicides on 2015-06-24
No homicides on 2015-06-22
No homicides on 2015-06-19
No homicides on 2015-06-15
No homicides on 2015-06-11
No homicides on 2015-06-09
No homicides on 2015-06-02
No homicides on 2015-05-27
No homicides on 2015-05-26
No homicides on 2015-05-22
No homicides on 2015-05-19
No homicides on 2015-05-17
No homicides on 2015-05-16
No homicides on 2015-05-12
No homicides on 2015-05-11
No homicides on 2015-05-08
No homicides on 2015-05-06
No homicides on 2015-05-04
No homicides on 2015-05-02
No homicides on 2015-04-27
No homicides on 2015-04-22
No homicides on 2015-04-16
No homicides on 2015-04-14
No homicides on 2015-04-13
No homicides on 2015-04-12
No homicides on 2015-04-09
No homicides on 2015-04-06
No homicides on 2015-04-05
No homicides on 2015-03-23
No homicides on 2015-03-18
No homicides on 2015-03-17
No homicides on 2015-03-14
No homicides on 2015-03-13
No homicides on 2015-03-12
No homicides on 2015-03-11
No homicides on 2015-03-10
No homicides on 2015-03-06
No homicides on 2015-03-05
No homicides on 2015-03-04
No homicides on 2015-03-01
No homicides on 2015-02-28
No homicides on 2015-02-27
No homicides on 2015-02-26
No homicides on 2015-02-24
No homicides on 2015-02-23
No homicides on 2015-02-18
No homicides on 2015-02-17
No homicides on 2015-02-14
No homicides on 2015-02-12
No homicides on 2015-02-11
No homicides on 2015-02-07
No homicides on 2015-02-06
No homicides on 2015-02-05
No homicides on 2015-02-03
No homicides on 2015-01-28
No homicides on 2015-01-26
No homicides on 2015-01-22
No homicides on 2015-01-19
No homicides on 2015-01-15
No homicides on 2015-01-12
No homicides on 2015-01-11
No homicides on 2015-01-10
No homicides on 2015-01-07
No homicides on 2015-01-02
No homicides on 2015-01-01
No homicides on 2014-12-30
No homicides on 2014-12-29
No homicides on 2014-12-24
No homicides on 2014-12-20
No homicides on 2014-12-18
No homicides on 2014-12-14
No homicides on 2014-12-07
No homicides on 2014-12-06
No homicides on 2014-12-04
No homicides on 2014-12-02
No homicides on 2014-12-01
No homicides on 2014-11-29
No homicides on 2014-11-27
No homicides on 2014-11-26
No homicides on 2014-11-24
No homicides on 2014-11-23
No homicides on 2014-11-20
No homicides on 2014-11-14
No homicides on 2014-11-12
No homicides on 2014-11-11
No homicides on 2014-10-30
No homicides on 2014-10-25
No homicides on 2014-10-21
No homicides on 2014-10-20
No homicides on 2014-10-17
No homicides on 2014-10-15
No homicides on 2014-10-13
No homicides on 2014-10-01
No homicides on 2014-09-24
No homicides on 2014-09-23
No homicides on 2014-09-16
No homicides on 2014-09-15
No homicides on 2014-09-12
No homicides on 2014-09-07
No homicides on 2014-09-03
No homicides on 2014-09-02
No homicides on 2014-08-28
No homicides on 2014-08-23
No homicides on 2014-08-22
No homicides on 2014-08-13
No homicides on 2014-08-09
No homicides on 2014-08-08
No homicides on 2014-08-07
No homicides on 2014-07-30
No homicides on 2014-07-28
No homicides on 2014-07-27
No homicides on 2014-07-26
No homicides on 2014-07-17
No homicides on 2014-07-16
No homicides on 2014-07-10
No homicides on 2014-06-29
No homicides on 2014-06-20
No homicides on 2014-06-16
No homicides on 2014-06-14
No homicides on 2014-06-11
No homicides on 2014-06-08
No homicides on 2014-06-02
No homicides on 2014-05-28
No homicides on 2014-05-23
No homicides on 2014-05-20
No homicides on 2014-05-15
No homicides on 2014-05-13
No homicides on 2014-05-12
No homicides on 2014-05-08
No homicides on 2014-05-07
No homicides on 2014-05-02
No homicides on 2014-04-29
No homicides on 2014-04-22
No homicides on 2014-04-21
No homicides on 2014-04-17
No homicides on 2014-04-16
No homicides on 2014-04-14
No homicides on 2014-04-12
No homicides on 2014-04-10
No homicides on 2014-04-08
No homicides on 2014-04-06
No homicides on 2014-04-04
No homicides on 2014-04-03
No homicides on 2014-04-02
No homicides on 2014-03-30
No homicides on 2014-03-29
No homicides on 2014-03-27
No homicides on 2014-03-24
No homicides on 2014-03-23
No homicides on 2014-03-17
No homicides on 2014-03-13
No homicides on 2014-03-09
No homicides on 2014-03-08
No homicides on 2014-03-07
No homicides on 2014-03-06
No homicides on 2014-03-04
No homicides on 2014-03-03
No homicides on 2014-02-26
No homicides on 2014-02-25
No homicides on 2014-02-23
No homicides on 2014-02-19
No homicides on 2014-02-18
No homicides on 2014-02-17
No homicides on 2014-02-16
No homicides on 2014-02-15
No homicides on 2014-02-11
No homicides on 2014-02-08
No homicides on 2014-02-02
No homicides on 2014-01-30
No homicides on 2014-01-27
No homicides on 2014-01-24
No homicides on 2014-01-23
No homicides on 2014-01-21
No homicides on 2014-01-18
No homicides on 2014-01-14
No homicides on 2014-01-13
No homicides on 2014-01-12
No homicides on 2014-01-10
No homicides on 2014-01-09
No homicides on 2014-01-07
No homicides on 2014-01-04
No homicides on 2014-01-02
No homicides on 2014-01-01

Let's get the latitudes and longitudes of every murder in 2015 (Manya Brachear asked).


In [16]:
coordinates = []
for homicide in homicides:
    if not homicide['Occ Date'].startswith('2015-'):
        continue
    # Since the format of this field is (x, y) (or y, x? I always confuse the two) we need to extract just x and y
    try:
        coordinates.append(
            (homicide['Geocode Override'][1:-1].split(',')[0], homicide['Geocode Override'][1:-1].split(',')[1]))
    except:
        # Not valid/expected lat/long format
        continue

In [17]:
print len(coordinates)


484

In [21]:
for coordinate in coordinates:
    print '%s,%s' % (coordinate[0].strip(), coordinate[1].strip())


41.87549740076065,-87.71006070077419
41.99511721730232,-87.68506787717342
41.75300158560276,-87.60407656431198
41.715926080942154,-87.6460363715887
41.784969329833984,-87.6525650024414
41.75092315673828,-87.66917419433594
41.87679022550583,-87.74513997137547
41.877763867378235,-87.73800395429134
41.88046216964722,-87.74548664689064
41.90096664428711,-87.72660064697266
41.765151992440224,-87.64943540096283
41.951365023851395,-87.76714414358139
41.790470123291016,-87.6502685546875
41.858261,-87.653007
41.729496002197266,-87.566162109375
41.87741115689278,-87.75500379502773
41.872432708740234,-87.71296691894531
41.681470423936844,-87.62647099792957
41.74011993408203,-87.66717529296875
41.8740838766098,-87.76458531618118
41.883392333984375,-87.7058334350586
41.79697036743164,-87.65287780761719
41.76420249044895,-87.56497532129288
41.76323318481445,-87.64591979980469
41.76974105834961,-87.6594467163086
41.8737678527832,-87.7481918334961
41.75372314453125,-87.61934661865234
41.909419298172,-87.75896742939949
41.83688499033451,-87.72830441594124
41.66349157691002,-87.6197312772274
41.76416493952274,-87.65427343547344
41.96714782714844,-87.71367645263672
42.000484466552734,-87.68230438232422
41.723598,-87.606918
41.752162,-87.710075
41.893756,-87.751396
41.7517248541117,-87.5701063871384
41.7517248541117,-87.5701063871384
41.863189,-87.733283
41.86507,-87.703491
41.815864,-87.689178
41.7883329838514,-87.6843738555908
41.864612,-87.725463
41.8237582594156,-87.61893466115
41.8822418153286,-87.6792857050896
41.797424,-87.654098
41.772445,-87.681236
41.753452,-87.552421
41.7506003379822,-87.6343164592981
41.885379999876,-87.7402201294899
41.753643,-87.669235
41.7471697926521,-87.5747217983007
41.859764,-87.711219
41.7723751813173,-87.6533199101686
41.8022348731756,-87.6111247390509
41.676528,-87.628265
41.850124,-87.624206
41.806934,-87.615257
41.7406647652388,-87.7000091224909
41.712406,-87.619728
41.745491,-87.684371
41.8766983598471,-87.7616140991449
41.902896,-87.75473
41.8837632983923,-87.671847268939
41.920963,-87.776237
41.767269,-87.674026
41.792312040925,-87.6463870704174
41.884784,-87.741485
41.858261,-87.653007
41.776008,-87.594085
41.96297,-87.652587
41.909,-87.772132
41.909,-87.772132
41.97303,-87.727302
41.8789554387331,-87.74515673518181
41.899089,-87.697677
41.74834460020065,-87.55014538764954
41.733249,-87.668205
41.697086,-87.540985
41.877292,-87.756103
41.851821,-87.623313
41.92166022956371,-87.66866616904736
41.67205,-87.651809
41.76690950989723,-87.63725012540817
41.77473,-87.664985
41.751468,-87.674728
41.913973689079285,-87.69482508301735
41.96367636322975,-87.65643060207367
41.84896230697632,-87.6929797232151
41.855155,-87.711807
41.72478340566158,-87.6274674385786
41.831043,-87.679313
41.7702763527632,-87.6833351701498
41.924716,-87.679527
41.75750732421875,-87.59112548828125
41.749046325683594,-87.65093231201172
41.866729736328125,-87.73160552978516
41.866729736328125,-87.73160552978516
41.77719511091709,-87.70217031240463
41.7658805847168,-87.64842987060547
41.7625617980957,-87.64521789550781
41.864230781793594,-87.66014412045479
41.738624572753906,-87.70101165771484
41.90958786010742,-87.67179107666016
41.88096618652344,-87.754638671875
41.88337326049805,-87.7077407836914
41.77137756347656,-87.58293914794922
41.85826873779297,-87.6511001586914
41.9406852722168,-87.72518157958984
41.77930936217308,-87.67772264778614
41.89248275756836,-87.75045013427734
41.72402232885361,-87.5920046120882
41.83072529733181,-87.64519214630127
41.88679151237011,-87.74891182780266
41.98450469970703,-87.69035339355469
41.83580017089844,-87.6504898071289
41.76045608520508,-87.6458511352539
41.749656,-87.624107
41.77372360229492,-87.60977172851562
41.75808334350586,-87.60084533691406
41.86223387718201,-87.71765470504761
41.882877349853516,-87.72782897949219
41.71367645263672,-87.62329864501953
41.691442877054214,-87.6599308848381
41.85919952392578,-87.71537780761719
41.842247009277344,-87.72727966308594
41.72749377787113,-87.66277268528938
41.75651168823242,-87.55228424072266
41.73261260986328,-87.6596908569336
41.73261260986328,-87.6597908569336
41.8937686085701,-87.70669654011726
41.74286651611328,-87.55006408691406
41.90428161621094,-87.75869750976562
41.8889045715332,-87.7496566772461
41.94822311401367,-87.71556091308594
41.88696206562131,-87.63013947168031
42.016894072294235,-87.67357796430588
41.74956130981445,-87.57141876220703
41.86449432373047,-87.73403930664062
41.89308166503906,-87.72199249267578
41.83879852294922,-87.72891235351562
41.75822067260742,-87.63533782958984
41.67595446109772,-87.61658303439617
41.904808044433594,-87.74690246582031
41.756656646728516,-87.67296600341797
41.860450744628906,-87.73269653320312
41.681609228253365,-87.61969707906246
41.680744,-87.626029
41.65723331272602,-87.60255441069603
41.878858879208565,-87.72937193512917
41.87954330444336,-87.72251892089844
41.797088623046875,-87.76766967773438
41.72490879893303,-87.63008259236813
41.90894119441509,-87.72274754941463
41.78593826293945,-87.66525268554688
41.80402755737305,-87.59160614013672
41.78367233276367,-87.65738677978516
41.88867950439453,-87.7520523071289
41.872249603271484,-87.69441223144531
41.770328521728516,-87.5730972290039
41.89345169067383,-87.76100158691406
41.80852800607681,-87.61622093617916
41.868160247802734,-87.69996643066406
41.85676574707031,-87.71356964111328
41.910972,-87.773132
41.819236755371094,-87.60568237304688
41.739749908447266,-87.657958984375
41.742488861083984,-87.6677474975586
41.697601,-87.647758
41.74557113647461,-87.59134674072266
41.90007,-87.69963
41.750492095947266,-87.59996032714844
41.78658150136471,-87.68070191144943
41.67633466422558,-87.61634632945061
42.02060021460056,-87.67182514071465
41.790569,-87.642982
41.882602,-87.720863
41.84855651855469,-87.69306945800781
41.78725051879883,-87.64764404296875
41.74401752650738,-87.60484769940376
41.80069260299206,-87.70258001983166
41.89556635916233,-87.7224538475275
41.890052407979965,-87.7606250345707
41.90552520751953,-87.76318359375
42.00804948806763,-87.65950709581375
41.91335543990135,-87.6630449295044
41.89878836274147,-87.7482620626688
41.761905670166016,-87.61431121826172
41.69164203107357,-87.63048492372036
41.854000091552734,-87.69666290283203
41.85365295410156,-87.72742462158203
41.69097137451172,-87.6280288696289
41.879955,-87.735649
41.8018647283316,-87.6551304012537
41.76494814455509,-87.6591745018959
41.6778206080198,-87.6287005841732
41.735702008009,-87.6324657350779
41.686565,-87.617195
42.01246306300163,-87.67455160617828
41.9670874625444,-87.6629228889942
41.70264311134815,-87.56447106599808
41.80857293307781,-87.67512492835522
41.703178,-87.629547
41.839984,-87.721115
41.748016,-87.589721
41.747959,-87.637001
41.946983,-87.772705
41.876914,-87.703178
41.741107,-87.586074
41.725269,-87.657035
41.790615,-87.656852
41.763603,-87.676414
41.77135527133942,-87.57649272680283
41.74272067844868,-87.56330899894238
41.92124515771866,-87.79170513153076
41.764179,-87.698173
41.788367852568626,-87.61588633060455
41.763920187950134,-87.61506892740726
41.924404,-87.756927
41.733184,-87.604278
41.895946,-87.693428
41.688198,-87.643814
41.78455911576748,-87.61568114161491
41.708343,-87.651741
41.748287,-87.701965
41.762641,-87.589347
41.766128,-87.68975
41.81634195148945,-87.6263053715229
41.76387995481491,-87.5793707370758
41.915016,-87.689941
41.719192,-87.64402
41.8481120467186,-87.7126148343086
41.687873,-87.636535
41.79047,-87.650268
41.930697932839394,-87.75140225887299
41.930697932839394,-87.75140225887299
41.97314187884331,-87.68438592553139
41.93267,-87.691925
41.872901,-87.713798
41.6552848815918,-87.60883331298828
41.887027740478516,-87.74748229980469
41.74806594848633,-87.63145446777344
41.70080244541168,-87.5632493197918
41.995281502604485,-87.68605962395668
41.758766174316406,-87.60577392578125
41.743099212646484,-87.54700469970703
41.805167868733406,-87.67345391213894
41.96761518716812,-87.65894517302513
41.900455355644226,-87.75670632719994
41.69953536987305,-87.62936401367188
41.69953536987305,-87.62936401367188
41.77675247192383,-87.67418670654297
41.742509454488754,-87.55146704614162
41.805877685546875,-87.72632598876953
41.917137145996094,-87.69963073730469
41.769447,-87.621307
41.83701507747173,-87.65858441591263
41.78195571899414,-87.66999053955078
41.82877667248249,-87.62562811374664
41.95573425292969,-87.72312927246094
41.96943171322346,-87.65621937811375
41.85253635048866,-87.69429333508015
41.93540185689926,-87.65356063842773
41.79334066808224,-87.715023458004
41.79334066808224,-87.715023458004
41.86262212693691,-87.65195734798908
41.75053024291992,-87.58251953125
41.78877639770508,-87.66844940185547
41.883385106921196,-87.74531498551369
42.014163970947266,-87.66968536376953
41.67222820222378,-87.65409640967846
41.84933580458164,-87.69299380481243
41.687259,-87.635826
41.7362174987793,-87.62311553955078
41.91033172607422,-87.74549102783203
41.90887078642845,-87.74613448808193
41.752628326416016,-87.60314178466797
41.98073959350586,-87.84066772460938
41.817474365234375,-87.61873626708984
41.900474801659584,-87.7543057501316
41.8133659362793,-87.60636138916016
41.77873611450195,-87.70002746582031
41.816139221191406,-87.70393371582031
41.96317948400974,-87.65613622963428
41.880523681640625,-87.71273803710938
41.813846588134766,-87.6715316772461
41.75027444958687,-87.60400213301182
41.962164267897606,-87.66098029911518
41.751058995723724,-87.60771632194519
42.020865082740784,-87.67063423991203
41.74257278442383,-87.56087493896484
41.9099644571543,-87.7312682569027
41.85408020019531,-87.72941589355469
41.78364944458008,-87.66276550292969
41.758122593164444,-87.63477645814419
41.86186218261719,-87.71615600585938
41.99005588889122,-87.67051622271538
41.90263666212559,-87.73316256701946
41.831116899847984,-87.62029655277729
41.754188537597656,-87.55104064941406
41.89460372924805,-87.72079467773438
41.726089641451836,-87.65068396925926
41.69953536987305,-87.62936401367188
41.81142807006836,-87.66834259033203
41.801326751708984,-87.68939971923828
41.916358947753906,-87.69257354736328
41.872420236468315,-87.73312568664551
41.96316406130791,-87.68319837749004
41.65565013885498,-87.59499661624432
41.8051643371582,-87.66400909423828
41.81578941643238,-87.61825136840343
41.88235580921173,-87.76662446558475
41.7619743347168,-87.59053802490234
41.72682189941406,-87.58704376220703
41.77486762404442,-87.58887447416782
41.77076183259487,-87.62678481638432
41.75542026758194,-87.56264984607697
41.749053955078125,-87.61542510986328
41.8681755065918,-87.69874572753906
41.90099582076073,-87.72386468946934
41.96542717516422,-87.73851558566093
41.96542717516422,-87.73851558566093
41.99972525238991,-87.68102511763573
41.8672127276659,-87.71412827074528
41.89018249511719,-87.7224349975586
41.96720886230469,-87.70686340332031
41.75190734863281,-87.57015228271484
41.75825469195843,-87.60776996612549
41.878047943115234,-87.75535583496094
41.78723193705082,-87.6255563646555
41.78033262491226,-87.60050050914288
41.76235109567642,-87.59721949696541
41.89308166503906,-87.72199249267578
41.84798812866211,-87.70671081542969
41.88839340209961,-87.75
41.751983642578125,-87.70284271240234
41.7431526184082,-87.60222625732422
41.876583099365234,-87.66895294189453
41.901283264160156,-87.72469329833984
41.90308380126953,-87.7094497680664
41.828026324510574,-87.60264560580254
41.814720153808594,-87.67033386230469
41.86351664364338,-87.65241399407387
41.901687,-87.765983
41.898231506347656,-87.75979614257812
41.77754592895508,-87.66329193115234
41.696791872382164,-87.65566349029541
41.74757766723633,-87.55802154541016
41.87440171837807,-87.72503547370434
41.89387893676758,-87.71175384521484
41.87681034207344,-87.63328582048416
41.6959228515625,-87.63679504394531
41.864433,-87.713294
41.808650970458984,-87.68486022949219
41.6959228515625,-87.63679504394531
41.87542724609375,-87.73374938964844
41.923775151371956,-87.78392471373081
41.93023592233658,-87.71718464791775
41.923755034804344,-87.77720645070076
41.75874710083008,-87.6329345703125
41.79877471923828,-87.64439392089844
41.81981658935547,-87.70161437988281
41.9072380065918,-87.64765930175781
41.788313537836075,-87.68530324101448
41.887062072753906,-87.745849609375
41.790035247802734,-87.66656494140625
41.898877546191216,-87.74838544428349
41.887590140104294,-87.71603062748909
41.75826206803322,-87.61517688632011
41.87586084008217,-87.70279325544834
41.69822311401367,-87.6283950805664
41.92166022956371,-87.66866616904736
41.86608485877514,-87.65746727585793
41.745129972696304,-87.60130651295185
41.87197297811508,-87.70114503800869
41.80535888671875,-87.60330963134766
41.90188980102539,-87.74629974365234
41.773036,-87.62236
41.92384958267212,-87.77834638953209
41.863033294677734,-87.7345199584961
41.97366692125797,-87.65755847096443
41.76020050048828,-87.55979919433594
41.930885314941406,-87.77523040771484
41.770641803741455,-87.64656476676464
41.97338528931141,-87.65766642987728
41.88274383544922,-87.68551635742188
41.88559341430664,-87.71090698242188
41.7086296081543,-87.63958740234375
41.74757480621338,-87.60450035333633
41.87884546816349,-87.70406529307365
41.884407699108124,-87.65248775482178
41.78346544504166,-87.60592393577099
41.91034600138664,-87.69914478063583
41.94204702973366,-87.73202665150166
41.740570068359375,-87.54503631591797
41.679721,-87.623085
41.84810467064381,-87.7130513638258
41.962290331721306,-87.71320089697838
41.788719,-87.628784
41.90276809036732,-87.73112945258617
41.81467495858669,-87.59894214570522
41.68511199951172,-87.6632080078125
41.909620463848114,-87.76559382677078
41.90422439575195,-87.76485443115234
41.83935597538948,-87.62197963893414
41.673072814941406,-87.65724182128906
41.718639,-87.647651
41.85792960226536,-87.6544913649559
41.81819066405296,-87.63559184968472
41.81819066405296,-87.63559184968472
41.78644739091396,-87.72302784025669
41.875271424651146,-87.72199183702469
41.7357177734375,-87.68943786621094
41.86648941040039,-87.72295379638672
41.857215881347656,-87.7220458984375
41.857215881347656,-87.7220458984375
41.90308392047882,-87.73114286363125
41.87141036987305,-87.72195434570312
41.78266906738281,-87.68827056884766
41.89501953125,-87.77265167236328
41.683246,-87.669494
41.796382904052734,-87.69840240478516
41.79697036743164,-87.65287780761719
41.74348175525665,-87.62567639350891
41.836345,-87.657249
41.727020263671875,-87.5964584350586
41.70932388305664,-87.61538696289062
41.80946946144104,-87.60741390287876
41.90933609008789,-87.72563934326172
41.69841003417969,-87.63380432128906
41.797424,-87.642448
41.97446060180664,-87.77855682373047
41.73586654663086,-87.62211608886719
41.81819066405296,-87.63559184968472
41.888355910778046,-87.72347442805767
41.74556350708008,-87.60662841796875
41.701637268066406,-87.61762237548828
41.795555,-87.619712
41.84522247314453,-87.72370147705078
41.88483428955078,-87.73595428466797
41.8007698059082,-87.69173431396484
41.74797439575195,-87.67343139648438
41.791568756103516,-87.68489074707031
41.75370633602142,-87.54996433854103
41.80173110961914,-87.65369415283203
41.759803771972656,-87.65312194824219
41.801696,-87.623123
41.786827087402344,-87.64289093017578
41.90650939941406,-87.73414611816406
41.896541595458984,-87.76510620117188
41.879886,-87.736633
41.761653900146484,-87.65567779541016
41.78083038330078,-87.68891906738281
41.900630950927734,-87.75241088867188
41.685161143541336,-87.6253940910101
41.77498245239258,-87.64795684814453
41.674732,-87.620765
41.86090014874935,-87.70792029798031
41.797843,-87.643157
41.77383804321289,-87.66568756103516
41.80325947701931,-87.65127405524254
41.875966116786,-87.74537734687328
41.96648329496384,-87.6502051949501
41.76313781738281,-87.65250396728516
41.96864700317383,-87.71489715576172
41.912742614746094,-87.76469421386719
41.7430305480957,-87.65753173828125
41.774775087833405,-87.61276759207249
41.77017778158188,-87.61458680033684
41.79904556274414,-87.64685821533203
41.900631710886955,-87.75324292480946
41.72701232135296,-87.64111518859863
41.75310082733631,-87.67204910516739
41.76525995135307,-87.64392882585526
41.78710386157036,-87.63026498258114
41.78710386157036,-87.63026498258114
41.87274932861328,-87.73117065429688
41.72932815551758,-87.59772491455078
41.80852197110653,-87.66016691923141
41.795753479003906,-87.66255950927734
41.873554,-87.694236
41.953147888183594,-87.7107925415039
41.744319915771484,-87.59687042236328
41.73358917236328,-87.55036163330078

In [ ]: